123456/PO PHP H5/Julian - Felix/gevangenis_gegevens.php

<!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" href="style/style.css"> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <html><h1>gevangenis gegevens</h1></html> <?php include('db.php'); $gevangenisID = $_GET['gevangenisID']; $query = "select * from gevangenis where gevangenisID = $gevangenisID"; $result = mysqli_query($db, $query); while($row = mysqli_fetch_array($result)){ echo "<h2>{$row['naam']}</h2>"; echo "<div>plaats: {$row['plaats']}</div>"; echo "<div>aantal cellen: {$row['cellen']}</div>"; } $query = "select * from moordenaar where gevangenisID = $gevangenisID"; $result = mysqli_query($db, $query); echo "<h2>gevangenen:</h2>"; while($row = mysqli_fetch_array($result)){ echo "<div><a href='moordenaars_gegevens.php?moordenaarID={$row['moordenaarID']}'>{$row['moordenaarID']} {$row['voornaam']} {$row['tweedeNaam']} {$row['tussenvoegsel']} {$row['achternaam']}</a></div>"; } ?> <button id="button" onclick="location.href='moorden.php'">moorden</button> <button id="button" onclick="location.href='moordenaars.php'">moordenaars</button> <button id="button"onclick="location.href='slachtoffers.php'">slachtoffers</button> <button id="button"onclick="location.href='index.php'">homepagina</button> </body> </html>

Resultaat

Made by Thijs Aarnoudse